﻿CREATE TABLE [dbo].[Artikel] (
    [ID]            BIGINT          IDENTITY (1, 1) NOT NULL,
    [Bezeichnung]   NVARCHAR (50)   NOT NULL,
    [fkWarengruppe] BIGINT          NOT NULL,
    [VKPreis]       DECIMAL (18, 2) NOT NULL,
    [Deleted]       BIT             NOT NULL,
    [fkTaxID]       BIGINT          NOT NULL,
    [Negative]      BIT             NOT NULL,
    [EANNummer]     BIGINT          NOT NULL,
    [fkGebindeID]   BIGINT          NOT NULL, 
	[Bestand]       DECIMAL (18, 2) NOT NULL,
	-- Inidcates that the article can't be modified.
	[CanBeModified] BIT				NOT NULL default(-1),
    [TimeStamp]		ROWVERSION		NOT NULL
);

